sat_results
Index(['DBN', 'SCHOOL NAME', 'Num of SAT Test Takers',
'SAT Critical Reading Avg. Score', 'SAT Math Avg. Score',
'SAT Writing Avg. Score'],
dtype='object')
DBN SCHOOL NAME \
0 01M292 HENRY STREET SCHOOL FOR INTERNATIONAL STUDIES
1 01M448 UNIVERSITY NEIGHBORHOOD HIGH SCHOOL
2 01M450 EAST SIDE COMMUNITY SCHOOL
3 01M458 FORSYTH SATELLITE ACADEMY
4 01M509 MARTA VALLE HIGH SCHOOL
Num of SAT Test Takers SAT Critical Reading Avg. Score SAT Math Avg. Score \
0 29 355 404
1 91 383 423
2 70 377 402
3 7 414 401
4 44 390 433
SAT Writing Avg. Score
0 363
1 366
2 370
3 359
4 384
hs_directory
Index(['dbn', 'school_name', 'borough', 'building_code', 'phone_number',
'fax_number', 'grade_span_min', 'grade_span_max', 'expgrade_span_min',
'expgrade_span_max', 'bus', 'subway', 'primary_address_line_1', 'city',
'state_code', 'postcode', 'website', 'total_students', 'campus_name',
'school_type', 'overview_paragraph', 'program_highlights',
'language_classes', 'advancedplacement_courses', 'online_ap_courses',
'online_language_courses', 'extracurricular_activities',
'psal_sports_boys', 'psal_sports_girls', 'psal_sports_coed',
'school_sports', 'partner_cbo', 'partner_hospital', 'partner_highered',
'partner_cultural', 'partner_nonprofit', 'partner_corporate',
'partner_financial', 'partner_other', 'addtl_info1', 'addtl_info2',
'start_time', 'end_time', 'se_services', 'ell_programs',
'school_accessibility_description', 'number_programs', 'priority01',
'priority02', 'priority03', 'priority04', 'priority05', 'priority06',
'priority07', 'priority08', 'priority09', 'priority10', 'Location 1',
'Community Board', 'Council District', 'Census Tract', 'BIN', 'BBL',
'NTA'],
dtype='object')
dbn school_name borough \
0 17K548 Brooklyn School for Music & Theatre Brooklyn
1 09X543 High School for Violin and Dance Bronx
2 09X327 Comprehensive Model School Project M.S. 327 Bronx
3 02M280 Manhattan Early College School for Advertising Manhattan
4 28Q680 Queens Gateway to Health Sciences Secondary Sc... Queens
building_code phone_number fax_number grade_span_min grade_span_max \
0 K440 718-230-6250 718-230-6262 9.0 12
1 X400 718-842-0687 718-589-9849 9.0 12
2 X240 718-294-8111 718-294-8109 6.0 12
3 M520 718-935-3477 NaN 9.0 10
4 Q695 718-969-3155 718-969-3552 6.0 12
expgrade_span_min expgrade_span_max \
0 NaN NaN
1 NaN NaN
2 NaN NaN
3 9.0 14.0
4 NaN NaN
... priority08 priority09 \
0 ... NaN NaN
1 ... NaN NaN
2 ... NaN NaN
3 ... NaN NaN
4 ... NaN NaN
priority10 Location 1 \
0 NaN 883 Classon Avenue\nBrooklyn, NY 11225\n(40.67...
1 NaN 1110 Boston Road\nBronx, NY 10456\n(40.8276026...
2 NaN 1501 Jerome Avenue\nBronx, NY 10452\n(40.84241...
3 NaN 411 Pearl Street\nNew York, NY 10038\n(40.7106...
4 NaN 160 20 Goethals Avenue\nJamaica, NY 11432\n(40...
Community Board Council District Census Tract BIN BBL \
0 9.0 35.0 213.0 3029686.0 3.011870e+09
1 3.0 16.0 135.0 2004526.0 2.026340e+09
2 4.0 14.0 209.0 2008336.0 2.028590e+09
3 1.0 1.0 29.0 1001388.0 1.001130e+09
4 8.0 24.0 1267.0 4539721.0 4.068580e+09
NTA
0 Crown Heights South ...
1 Morrisania-Melrose ...
2 West Concourse ...
3 Chinatown ...
4 Pomonok-Flushing Heights-Hillcrest ...
[5 rows x 64 columns]
math_results
Index(['DBN', 'Grade', 'Year', 'Category', 'Number Tested', 'Mean Scale Score',
'Level 1 #', 'Level 1 %', 'Level 2 #', 'Level 2 %', 'Level 3 #',
'Level 3 %', 'Level 4 #', 'Level 4 %', 'Level 3+4 #', 'Level 3+4 %'],
dtype='object')
DBN Grade Year Category Number Tested Mean Scale Score Level 1 # \
0 01M015 3 2006 All Students 39 667 2
1 01M015 3 2007 All Students 31 672 2
2 01M015 3 2008 All Students 37 668 0
3 01M015 3 2009 All Students 33 668 0
4 01M015 3 2010 All Students 26 677 6
Level 1 % Level 2 # Level 2 % Level 3 # Level 3 % Level 4 # Level 4 % \
0 5.1 11 28.2 20 51.3 6 15.4
1 6.5 3 9.7 22 71 4 12.9
2 0 6 16.2 29 78.4 2 5.4
3 0 4 12.1 28 84.8 1 3
4 23.1 12 46.2 6 23.1 2 7.7
Level 3+4 # Level 3+4 %
0 26 66.7
1 26 83.9
2 31 83.8
3 29 87.9
4 8 30.8
class_size
Index(['CSD', 'BOROUGH', 'SCHOOL CODE', 'SCHOOL NAME', 'GRADE ',
'PROGRAM TYPE', 'CORE SUBJECT (MS CORE and 9-12 ONLY)',
'CORE COURSE (MS CORE and 9-12 ONLY)', 'SERVICE CATEGORY(K-9* ONLY)',
'NUMBER OF STUDENTS / SEATS FILLED', 'NUMBER OF SECTIONS',
'AVERAGE CLASS SIZE', 'SIZE OF SMALLEST CLASS', 'SIZE OF LARGEST CLASS',
'DATA SOURCE', 'SCHOOLWIDE PUPIL-TEACHER RATIO'],
dtype='object')
CSD BOROUGH SCHOOL CODE SCHOOL NAME GRADE PROGRAM TYPE \
0 1 M M015 P.S. 015 Roberto Clemente 0K GEN ED
1 1 M M015 P.S. 015 Roberto Clemente 0K CTT
2 1 M M015 P.S. 015 Roberto Clemente 01 GEN ED
3 1 M M015 P.S. 015 Roberto Clemente 01 CTT
4 1 M M015 P.S. 015 Roberto Clemente 02 GEN ED
CORE SUBJECT (MS CORE and 9-12 ONLY) CORE COURSE (MS CORE and 9-12 ONLY) \
0 - -
1 - -
2 - -
3 - -
4 - -
SERVICE CATEGORY(K-9* ONLY) NUMBER OF STUDENTS / SEATS FILLED \
0 - 19.0
1 - 21.0
2 - 17.0
3 - 17.0
4 - 15.0
NUMBER OF SECTIONS AVERAGE CLASS SIZE SIZE OF SMALLEST CLASS \
0 1.0 19.0 19.0
1 1.0 21.0 21.0
2 1.0 17.0 17.0
3 1.0 17.0 17.0
4 1.0 15.0 15.0
SIZE OF LARGEST CLASS DATA SOURCE SCHOOLWIDE PUPIL-TEACHER RATIO
0 19.0 ATS NaN
1 21.0 ATS NaN
2 17.0 ATS NaN
3 17.0 ATS NaN
4 15.0 ATS NaN
ap_results
Index(['DBN', 'SchoolName', 'AP Test Takers ', 'Total Exams Taken',
'Number of Exams with scores 3 4 or 5'],
dtype='object')
DBN SchoolName AP Test Takers \
0 01M448 UNIVERSITY NEIGHBORHOOD H.S. 39.0
1 01M450 EAST SIDE COMMUNITY HS 19.0
2 01M515 LOWER EASTSIDE PREP 24.0
3 01M539 NEW EXPLORATIONS SCI,TECH,MATH 255.0
4 02M296 High School of Hospitality Management NaN
Total Exams Taken Number of Exams with scores 3 4 or 5
0 49.0 10.0
1 21.0 NaN
2 26.0 24.0
3 377.0 191.0
4 NaN NaN
grad_outcomes
Index(['Demographic', 'DBN', 'School Name', 'Cohort', 'Total Cohort',
'Total Grads - n', 'Total Grads - % of cohort', 'Total Regents - n',
'Total Regents - % of cohort', 'Total Regents - % of grads',
'Advanced Regents - n', 'Advanced Regents - % of cohort',
'Advanced Regents - % of grads', 'Regents w/o Advanced - n',
'Regents w/o Advanced - % of cohort',
'Regents w/o Advanced - % of grads', 'Local - n', 'Local - % of cohort',
'Local - % of grads', 'Still Enrolled - n',
'Still Enrolled - % of cohort', 'Dropped Out - n',
'Dropped Out - % of cohort'],
dtype='object')
Demographic DBN School Name Cohort \
0 Total Cohort 01M292 HENRY STREET SCHOOL FOR INTERNATIONAL 2003
1 Total Cohort 01M292 HENRY STREET SCHOOL FOR INTERNATIONAL 2004
2 Total Cohort 01M292 HENRY STREET SCHOOL FOR INTERNATIONAL 2005
3 Total Cohort 01M292 HENRY STREET SCHOOL FOR INTERNATIONAL 2006
4 Total Cohort 01M292 HENRY STREET SCHOOL FOR INTERNATIONAL 2006 Aug
Total Cohort Total Grads - n Total Grads - % of cohort Total Regents - n \
0 5 s s s
1 55 37 67.3 17
2 64 43 67.2 27
3 78 43 55.1 36
4 78 44 56.4 37
Total Regents - % of cohort Total Regents - % of grads \
0 s s
1 30.9 45.9
2 42.2 62.8
3 46.2 83.7
4 47.4 84.1
... Regents w/o Advanced - n \
0 ... s
1 ... 17
2 ... 27
3 ... 36
4 ... 37
Regents w/o Advanced - % of cohort Regents w/o Advanced - % of grads \
0 s s
1 30.9 45.9
2 42.2 62.8
3 46.2 83.7
4 47.4 84.1
Local - n Local - % of cohort Local - % of grads Still Enrolled - n \
0 s s s s
1 20 36.4 54.1 15
2 16 25 37.200000000000003 9
3 7 9 16.3 16
4 7 9 15.9 15
Still Enrolled - % of cohort Dropped Out - n Dropped Out - % of cohort
0 s s s
1 27.3 3 5.5
2 14.1 9 14.1
3 20.5 11 14.1
4 19.2 11 14.1
[5 rows x 23 columns]
demographics
Index(['DBN', 'Name', 'schoolyear', 'fl_percent', 'frl_percent',
'total_enrollment', 'prek', 'k', 'grade1', 'grade2', 'grade3', 'grade4',
'grade5', 'grade6', 'grade7', 'grade8', 'grade9', 'grade10', 'grade11',
'grade12', 'ell_num', 'ell_percent', 'sped_num', 'sped_percent',
'ctt_num', 'selfcontained_num', 'asian_num', 'asian_per', 'black_num',
'black_per', 'hispanic_num', 'hispanic_per', 'white_num', 'white_per',
'male_num', 'male_per', 'female_num', 'female_per'],
dtype='object')
DBN Name schoolyear fl_percent frl_percent \
0 01M015 P.S. 015 ROBERTO CLEMENTE 20052006 89.4 NaN
1 01M015 P.S. 015 ROBERTO CLEMENTE 20062007 89.4 NaN
2 01M015 P.S. 015 ROBERTO CLEMENTE 20072008 89.4 NaN
3 01M015 P.S. 015 ROBERTO CLEMENTE 20082009 89.4 NaN
4 01M015 P.S. 015 ROBERTO CLEMENTE 20092010 96.5
total_enrollment prek k grade1 grade2 ... black_num black_per \
0 281 15 36 40 33 ... 74 26.3
1 243 15 29 39 38 ... 68 28.0
2 261 18 43 39 36 ... 77 29.5
3 252 17 37 44 32 ... 75 29.8
4 208 16 40 28 32 ... 67 32.2
hispanic_num hispanic_per white_num white_per male_num male_per female_num \
0 189 67.3 5 1.8 158.0 56.2 123.0
1 153 63.0 4 1.6 140.0 57.6 103.0
2 157 60.2 7 2.7 143.0 54.8 118.0
3 149 59.1 7 2.8 149.0 59.1 103.0
4 118 56.7 6 2.9 124.0 59.6 84.0
female_per
0 43.8
1 42.4
2 45.2
3 40.9
4 40.4
[5 rows x 38 columns]